﻿CREATE TABLE [Security].[User] (
    [Id]                     UNIQUEIDENTIFIER NOT NULL,
    [Username]               NVARCHAR (128)   NOT NULL,
    [Email]                  NVARCHAR (128)   NOT NULL,
    [Password]               NVARCHAR (16)    NOT NULL,
    [PasswordQuestion]       NVARCHAR (256)   NULL,
    [PasswordAnswer]         NVARCHAR (128)   NULL,
    [IsApproved]             BIT              NOT NULL,
    [LastActivityDate]       DATETIME         NULL,
    [LastLoginDate]          DATETIME         NULL,
    [LastPasswordChangeDate] DATETIME         NULL,
    [CreationDate]           DATETIME         NULL,
    [IsOnLine]               BIT              NULL,
    [IsLockedOut]            BIT              NULL
);

